﻿CREATE PROCEDURE [dbo].[Facturas_DevolverPorId]

@facturaId int

AS
SELECT FacturaId, ClienteId, EmpleadoId, FechaHora, Iva
FROM Facturas
WHERE FacturaId=@facturaId;

SELECT FacturaDetalleId, FacturaId, ProductoId, Precio, Cantidad
FROM FacturaDetalles
WHERE FacturaId=@facturaId;